For each table name below, each subsequent line describes a field in the table.
The field description is given as "<field_name>|<data_type>[|<description]", where optional descriptions may describe a foreign key as "<table_name>.<field_name>".
Note that cb_2013_us_county_20m.<field_name> refers to fields in the KMZ table cb_2013_us_county_20m available at https://www.census.gov/geo/maps-data/data/kml/kml_counties.html.

compiled_market
premises|integer|grouping variable for records identified as duplicates 
name|string
address|string
po|string|mailing address for post office delivery, not used for county assignment
city|string
state|string
zip|string|5 digit ZIP code for USA, 3 digit forward sortation area for Canada
zip_ext|string|4 digit ZIP+4 for USA, 3 digit local delivery unit for Canada
source|string|abbreviations for the data providers described in the abstract
id|string|identifier used by the data provider

compiled_market_county
premises|integer|foreign key to compiled_market.premises
state|string|foreign key to cb_2013_us_county_20m.STATEFP
county|string|foreign key to cb_2013_us_county_20m.COUNTYFP
